Qid Examcode Question Qimpath opt1 opt2 opt3 opt4 opt5 opt6 opt7 opt8 opt9 opt10 opt11 opt12 opt13 opt14 opt15 impath1 impath2 impath3 impath4 impath5 impath6 impath7 impath8 impath9 impath10 impath11 impath12 impath13 impath14 impath15 answers uanswer CR Edit Delete
50 1Z0-082 In the SALES database, DEFERRED_SEGMENT_CREATION is TRUE. 50-quedb1.png T1, an index segment for the primary key, a LOB segment, and a lobindex segment no segments are created T1 only T1 and an index segment created for the primary key only T1, an index segment for the primary key, and a LOB segment only 3 SC edit delete
49 1Z0-082 Which three statements are true about views in an Oracle database? (Choose three.) Views can be updated without the need to re-grant privileges on the view Tables in the defining query of a view must always exist in order to create the view The WITH CHECK clause prevents certain rows from being displayed when querying the view Data Manipulation Language (DML) can always be used on views Inserting one or more rows using a view whose defining query contains a GROUP BY clause will cause an error Deleting one or more rows using a view whose defining query contains a GROUP BY clause will cause an error The WITH CHECK clause prevents certain rows from being updated or inserted 2,4,5 MC edit delete
48 1Z0-082 Examine this command: 48-quedb1.png Add the SEGMENT SPACE MANAGEMENT AUTO clause Set UNDO_TABLESPACE to UNDOTBS01 Add the NOLOGGING clause Make certain that the database operates in automatic undo management mode Add the ONLINE clause 2,4 MC edit delete
47 1Z0-082 Which two tasks can you perform using DBCA for databases? (Choose two.) Configure a nonstandard block size for a new database Register a new database with an available Enterprise Manager Management server Change the standard block size of an existing database Configure incremental backups for a new database Enable flashback database for an existing database 2,3 MC edit delete
46 1Z0-082 Which three statements are true about external tables in Oracle 18c and later releases? (Choose three.) External table files can be used for other external tables in a different database The ORACLE_LOADER access driver can be used to unload data from a database into an external table The ORACLE_DATAPUMP access driver can be used to unload data from a database into an external table They cannot be partitioned The ORACLE_DATAPUMP access driver can be used to load data into a database from an external table They support UPDATEs but not INSERTs and DELETEs 1,2,6 MC edit delete
45 1Z0-082 Examine the description of the BOOKS table: 45-quedb1.png The second ROLLBACK command does nothing The second ROLLBACK command replays the delete The first ROLLBACK command restores the 101 rows that were deleted, leaving the inserted row still to be committed The second ROLLBACK command undoes the insert The first ROLLBACK command restores the 101 rows that were deleted and commits the inserted row 4,5 MC edit delete
44 1Z0-082 Which three statements are true about Oracle synonyms? (Choose three.) A synonym cannot be created for a PL/SQL package A synonym can be available to all users A SEQUENCE can have a synonym A synonym created by one user can refer to an object belonging to another user Any user can drop a PUBLIC synonym 2,3,4 MC edit delete
43 1Z0-082 A script abc.sql must be executed to perform a job. 43-quedb1.png The command succeeds and HR will be connected to the orcl and abc.sql databases The command succeeds and HR will be connected to the orcl database instance, and the abc.sql script will be executed The command fails because the script must refer to the full path name The command fails and reports an error because @ is used twice 2 SC edit delete
42 1Z0-082 Your database instance was shut down normally and then started in NOMOUNT state. 42-quedb1.png The online redo logs are opened The online data files are opened The alert log records the execution details The Oracle background processes are started The initialization parameter file is read The control file is read 4,6 MC edit delete
41 1Z0-082 Which statement is true about aggregate functions? Aggregate functions can be nested to any number of levels The AVG function implicitly converts NULLS to zero Aggregate functions can be used in any clause of a SELECT statement The MAX and MIN functions can be used on columns with character data types 1 SC edit delete
40 1Z0-082 The CUSTOMERS table has a CUST_CREDIT_LIMIT column of data type NUMBER. Which two queries execute successfully? (Choose two.) SELECT NVL(cust_credit_limit * .15, ‘Not Available’) FROM customers; SELECT NVL2(cust_credit_limit * .15, ‘Not Available’) FROM customers; SELECT NVL(TO_CHAR(cust_credit_limit * .15), ‘Not Available’) FROM customers; SELECT TO_CHAR(NVL(cust_credit_limit * .15, ‘Not Available’)) FROM customers; SELECT NVL2(cust_credit_limit, TO_CHAR(cust_credit_limit * .15), ‘Not Available’) FROM customers; 2,3 MC edit delete
39 1Z0-082 Examine this description of the TRANSACTIONS table: 39-quedb1.png SELECT customer_id AS “CUSTOMER-ID”, transaction_date AS DATE, amount + 100 “DUES” FROM transactions; SELECT customer_id AS “CUSTOMER-ID”, transaction_date AS “DATE”, amount + 100 DUES FROM transactions; SELECT customer_id AS CUSTOMER-ID, transaction_date AS TRANS_DATE, amount + 100 “DUES AMOUNT” FROM transactions; SELECT customer_id CUSTID, transaction_date TRANS_DATE, amount + 100 DUES FROM transactions; SELECT customer_id AS ‘CUSTOMER-ID’, transaction_date AS DATE, amount + 100 ‘DUES AMOUNT’ FROM transactions; 2,4 MC edit delete
38 1Z0-082 Which three statements are true about time zones, date data types, and timestamp data types in an Oracle database? (Choose three.) The CURRENT_TIMESTAMP function returns data without time zone information A TIMESTAMP WITH LOCAL TIMEZONE data type column is stored in the database using the time zone of the session that inserted the row A TIMESTAMP data type column contains information about year, month, and day The DBTIMEZONE function can return an offset from Universal Coordinated Time (UTC) The SESSIONTIMEZONE function can return an offset from Universal Coordinated Time (UTC) 1,4,5 MC edit delete
37 1Z0-082 Which two are true about a SQL statement using SET operators such as UNION? (Choose two.) The data type group of each column returned by the second query must match the data type of the corresponding column returned by the first query. The number, but not names, of columns must be identical for all SELECT statements in the query. The data type of each column returned by the second query must exactly match the data type of the corresponding column returned by the first query. The names and number of columns must be identical for all SELECT statements in the query. The data type of each column returned by the second query must be implicitly convertible to the data type of the corresponding column returned by the first query. 1,3 MC edit delete
36 1Z0-082 Table EMPLOYEES contains columns including EMPLOYEE_ID, JOB_ID and SALARY. 36-quedb1.png Employee 100 will have SALARY set to the same value as the SALARY of employee 200 Employee 200 will have JOB_ID set to the same value as the JOB_ID of employee 100 Employee 200 will have SALARY set to the same value as the SALARY of employee 100 Employee 100 will have JOB_ID set to the same value as the JOB_ID of employee 200 Employees 100 and 200 will have the same JOB_ID as before the update command Employees 100 and 200 will have the same SALARY as before the update command 1,2 MC edit delete
35 1Z0-082 You want to apply the principle of Least Privilege in all your live databases. One of your requirements is to revoke unnecessary privileges from all users who have them using Privilege Analysis. Which three types of analyses can be done using the DBMS_PRIVILEGE_CAPTURE package? (Choose three.) analysis of all privileges used by all users including administrative users in the database analysis of all privileges used by all users but excluding administrative users in the database analysis of privileges that a user has on their own schema objects that they did not use analysis of privileges that a user has on their own schema objects that they did use analysis of privileges granted directly to a role that are then used by a user who has been granted that role analysis of privileges granted indirectly to a role that are then used by a user who has been granted that role 1,3,6 MC edit delete
34 1Z0-082 Which three statements are true about the tools used to configure Oracle Net Services? (Choose three.) The Oracle Net Configuration Assistant is only used when running the Oracle installer Oracle Net Manager can be used to centrally configure listeners on any database server target The lsnrctl utility requires a listener.ora file to exist before it is started Oracle Net Manager can be used to locally configure naming methods on a database server Enterprise Manager Cloud Control can be used to centrally configure listeners on any managed database server Enterprise Manager Cloud Control can be used to centrally configure net service names for any database server target 2,4.5 MC edit delete
33 1Z0-082 In your data center, Oracle Managed Files (OMF) is used for all databases. 33-quedb1.png Ensure that DB_RECOVERY_FILE_DEST and DB_CREATE_FILE_DEST each specify with at least 50 Mb of available space. Specify a path in the DATAFILE clause of the command specifying a location with at least 100M of available space. Ensure that DB_CREATE_FILE_DEST specifies a location with at least 100 Mb of available space. Add the AUTOEXTEND ON clause with NEXT set to 100M. Ensure that DB_RECOVERY_FILE_DEST and DB_CREATE_FILE_DEST each specify locations with at least 50 Mb of available space. 2,4 MC edit delete
32 1Z0-082 What is true about non-equijoin statement performance? (Choose two.) Table aliases can improve performance The BETWEEN condition always performs better than using the >= and <= conditions The join syntax used makes no difference to performance The BETWEEN condition always performs less well than using the >= and <= conditions The Oracle join syntax performs better than the SQL:1999 compliant ANSI join syntax 1,5 MC edit delete
31 1Z0-082 Which two statements are true about the DUAL table? (Choose two.) It can be accessed only by the SYS user It consists of a single row and single column of VARCHAR2 data type It can display multiple rows but only a single column It can be used to display only constants or pseudo columns It can be accessed by any user who has the SELECT privilege in any schema It can display multiple rows and columns 1,2 MC edit delete
30 1Z0-082 You need to calculate the number of days from 1st January 2019 until today. Dates are stored in the default format of DD-MON-RR. Which two queries give the required output? (Choose two.) SELECT TO_CHAR(SYSDATE, ‘DD-MON-YYYY’) – ’01-JAN-2019’ FROM DUAL; SELECT ROUND(SYSDATE – ’01-JAN-2019’) FROM DUAL; SELECT ROUND(SYSDATE – TO_DATE(‘01/JANUARY/2019’)) FROM DUAL; SELECT TO_DATE(SYSDATE, ‘DD/MONTH/YYYY’) – ‘01/JANUARY/2019’ FROM DUAL; SELECT SYSDATE – TO_DATE(’01-JANUARY-2019’) FROM DUAL; 1,2 MC edit delete
29 1Z0-082 Which two statements are true about trace files produced by the Oracle Database server? (Choose two.) They can be written by server processes Trace files are written to the Fast Recovery Area (FRA) They can be written by background processes All trace files contain error information that require contacting Oracle Support Trace file names are based on the database name concatenated with a sequential number 1,3 MC edit delete
28 1Z0-082 View the Exhibits and examine the structure of the COSTS and PROMOTIONS tables. 28-quedb1.png It gives an error because the ALL keyword is not valid It gives an error because the GROUP BY clause is not valid It executes successfully but does not give the required result It executes successfully and gives the required result 4 SC edit delete
27 1Z0-082 Which two statements are true about the rules of precedence for operators? (Choose two.) The concatenation operator | | is always evaluated before addition and subtraction in an expression NULLS influence the precedence of operators in an expression The + binary operator has the highest precedence in an expression in a SQL statement Arithmetic operators with equal precedence are evaluated from left to right within an expression Multiple parentheses can be used to override the default precedence of operators in an expression 3,5 MC edit delete
26 1Z0-082 Examine the description of the PROMOTIONS table: 26-quedb1.png SELECT promo_cost, promo_category FROM promotions ORDER BY by 1; SELECT DISTINCT promo_cost || ’ in ‘ || DISTINCT promo_category FROM promotions ORDER BY 1; SELECT DISTINCT promo_category || ‘ has ‘ || promo_cost AS COSTS FROM promotions ORDER BY 1; SELECT promo_category, DISTINCT promo_cost FROM promotions ORDER BY 2; SELECT DISTINCT promo_category, promo_cost FROM promotions ORDER BY 1; 4,5 MC edit delete
25 1Z0-082 Which two statements are true about views used for viewing tablespace and datafile information? (Choose two.) Tablespace free space can be viewed in V$TABLESPACE V$TABLESPACE displays information that is contained in the controlfile about tablespaces V$TABLESPACE displays information about tablespaces contained in the data dictionary Tablespace free space can be viewed in DBA_TABLESPACES A datafile can be renamed when the database is in MOUNT state and the new file name is displayed when querying DBA_DATA_FILES after the database is opened 2,5 MC edit delete
24 1Z0-082 The ORCL database has RESUMABLE__TIMEOUT = 7200 and DEFERRED_SEGMENT_CREATION = FALSE 24-quedb1.png Add a data file to DATA Drop other U1 objects in DATA Increase U1’s quota sufficiently in DATA Set DEFERRED_SEGMENT_CREATION to TRUE Grant UNLIMITED TABLESPACE to U1 Set AUTOEXTEND ON for data files in DATA 3,4,6 MC edit delete
23 1Z0-082 Which two statements are true about the results of using the INTERSECT operator in compound queries? (Choose two.) Column names in each SELECT in the compound query can be different The number of columns in each SELECT in the compound query can be different Reversing the order of the intersected tables can sometimes affect the output INTERSECT returns rows common to both sides of the compound query INTERSECT ignores NULLs 1,5 MC edit delete
22 1Z0-082 The INVOICE table has a QTY_SOLD column of data type NUMBER and an INVOICE_DATE column of data type DATE. NLS_DATE_FORMAT is set to DD-MON-RR. Which two are true about data type conversions involving these columns in query expressions? (Choose two.) CONCAT (qty_sold, invoice_date) : requires explicit conversion invoice_date = ’15-march-2019’ : uses implicit conversion invoie_date > ’01-02-2019’ : uses implicit conversion qty_sold BETWEEN ‘101’ AND ’110’ : uses implicit conversion qty_sold = ‘0554982’ uses implicit conversion 2,4 MC edit delete
21 1Z0-082 Examine the description of the CUSTOMERS table: 21-quedb1.png SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNT FROM customers WHERE cust_income_level IS NOT NULL AND due_amount IS NOT NULL; SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNT FROM customers WHERE cust_income_level != NULL AND cust_credit_level !=NULL; SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNT FROM customers WHERE cust_income_level <> NULL AND due_amount <> NULL; SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNT FROM customers WHERE cust_income_level != NULL AND due_amount != NULL; SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNT FROM customers WHERE cust_income_level IS NOT NULL AND cust_credit_limit IS NOT NULL; 5 SC edit delete
20 1Z0-082 Which two statements are true about the WHERE and HAVING clauses in a SELECT statement? (Choose two.) Aggregating functions and columns used in HAVING clauses must be specified in the SELECT list of a query WHERE and HAVING clauses can be used in the same statement only if applied to different table columns The HAVING clause can be used with aggregating functions in subqueries The WHERE clause can be used to exclude rows before dividing them into groups The WHERE clause can be used to exclude rows after dividing them into groups 3,4 MC edit delete
19 1Z0-082 You execute this command: 19-quedb1.png You can no longer monitor it You can reattach to it and monitor it It is paused and can be resumed It continues to run in the background It terminates 1,5 MC edit delete
18 1Z0-082 Which three Oracle database space management features will work with both Dictionary and Locally managed tablespaces? (Choose three.) Oracle Managed Files (OMF) Online table segment shrink Online index segment shrink Automatic data file extension (AUTOEXTEND) Capacity planning growth reports based on historical data in the Automatic Workload Repository (AWR) 1,4,5 MC edit delete
17 1Z0-082 In which three situations does a new transaction always start? (Choose three.) when issuing a SELECT FOR UPDATE statement after a CREATE TABLE AS SELECT statement was issued in the same session when issuing a TRUNCATE statement after a SELECT statement was issued in the same session when issuing a CREATE TABLE statement after a SELECT statement was issued in the same session when issuing the first Data Manipulation Language (DML) statement after a COMMIT OR ROLLBACK statement was issued in the same session when issuing a CREATE INDEX statement after a CREATE TABLE statement completed successfully in the same session when issuing a DML statement after a DML statement failed in the same session 1,4,6 MC edit delete
16 1Z0-082 Which two statements are true about space-saving features in an Oracle Database? (Choose two.) Private Temporary Tables (PTTS) store metadata in memory only An index created with the UNUSABLE attribute has no segment If they exist for a session, Private Temporary Tables (PTTs) are always dropped at the next COMMIT OR ROLLBACK statement An index that is altered to be UNUSABLE will retain its segment A table that is truncated will always have its segment removed 2,3 MC edit delete
15 1Z0-082 You want to use table compression suitable for OLTP that will: 15-quedb1.png COLUMN STORE COMPRESS FOR QUERY LOW ROW STORE COMPRESS BASIC COLUMN STORE COMPRESS FOR ARCHIVE LOW COLUMN STORE COMPRESS FOR ARCHIVE HIGH ROW STORE COMPRESS ADVANCED 5 SC edit delete
14 1Z0-082 Which three statements are true about single-row functions? (Choose three.) They can be used only in the WHERE clause of a SELECT statement The argument can be a column name, variable, literal or an expression The data type returned can be different from the data type of the argument They can be nested to any level They can accept only one argument They return a single result row per table 2,3,6 MC edit delete
13 1Z0-082 Which four account management capabilities can be configured using Oracle profiles? (Choose four.) the number of hours for which an account is locked after the configured number of login attempts has been reached the number of days for which an account may be inactive before it is locked the maximum amount of CPU time allowed for a user’s sessions before their account is locked the ability to prevent a password from ever being reused the number of password changes required within a period of time before a password can be reused the number of days for which an account is locked after the configured number of login attempts has been reached the maximum number of sessions permitted for a user before the account is locked 4,5,6,7 MC edit delete
12 1Z0-082 Which two statements are true about the ORDER BY clause when used with a SQL statement containing a SET operator such as UNION? (Choose two.) Column positions must be used in the ORDER BY clause Only column names from the first SELECT statement in the compound query are recognized The first column in the first SELECT of the compound query with the UNION operator is used by default to sort output in the absence of an ORDER BY clause Each SELECT statement in the compound query must have its own ORDER BY clause Each SELECT statement in the compound query can have its own ORDER BY clause 2,5 MC edit delete
11 1Z0-082 Evaluate these commands which execute successfully: 11-quedb1.png If sequence ORD_SEQ is dropped then the default value for column ORD_NO will be NULL for rows inserted into ORD_ITEMS Any user inserting rows into table ORD_ITEMS must have been granted access to sequence ORD_SEQ Column ORD_NO gets the next number from sequence ORD_SEQ whenever a row is inserted into ORD_ITEMS and no explicit value is given for ORD_NO Sequence ORD_SEQ cycles back to 1 after every 5000 numbers and can cycle 20 times Sequence ORD_SEQ is guaranteed not to generate duplicate numbers 2,5 MC edit delete
10 1Z0-082 Which three statements are true about dropping and unused columns in an Oracle database? (Choose three.) A primary key column referenced by another column as a foreign key can be dropped if using the CASCADE option. An UNUSED column’s space is reclaimed automatically when the block containing that column is next queried. An UNUSED column’s space is reclaimed automatically when the row containing that column is next queried. Partition key columns cannot be dropped. A DROP COLUMN command can be rolled back A column that is set to UNUSED still counts towards the limit of 1000 columns per table 1,2,6 MC edit delete
9 1Z0-082 Examine the description of the CUSTOMERS table: 09-quedb1.png SELECT * FROM customers WHERE city LIKE 'D_%'; SELECT * FROM customers WHERE city = '%D_'; SELECT * FROM customers WHERE city LIKE 'D_'; SELECT * FROM customers WHERE city = 'D_%'; 1 SC edit delete
8 1Z0-082 You want to write a query that prompts for two column names and the WHERE condition each time it is executed in a session but only prompts for the table name the first time it is executed. The variables used in your query are never undefined in your session. Which query can be used? SELECT &&col1, &&col2 FROM &table WHERE &&condition = &&cond; SELECT &col1, &col2 FROM &&table WHERE &condition; SELECT &col1, &col2 CFB2F2 FROM &table WHERE &condition; SELECT '&&col1', '&&col2' FROM &table WHERE &&condition = '&cond'; SELECT &&col1, &&col2 FROM &table WHERE &&condition; 2 SC edit delete
7 1Z0-082 Which three statements are true about a self join? (Choose three.) The ON clause must be used The query must use two different aliases for the table It must be an equijoin It must be an inner join The ON clause can be used It can be an outer join 2,4,5 MC edit delete
6 1Z0-082 Which two statements are true about the SET VERIFY ON command? (Choose two.) It can be used only in SQL*Plus It displays values for variables used only in the WHERE clause of a query It can be used in SQL Developer and SQL*Plus It displays values for variables created by the DEFINE command It displays values for variables prefixed with && 1,4 MC edit delete
5 1Z0-082 Which three functions are performed by dispatchers in a shared server configuration? (Choose three.) writing inbound request to the common request queue from all shared server connections checking for outbound shared server responses on the common outbound response queue receiving inbound requests from processes using shared server connections sending each connection input request to the appropriate shared server input queue broadcasting shared server session responses back to requesters on all connections sending shared server session responses back to requesters on the appropriate connection 1,3,4 MC edit delete
4 1Z0-082 Which three statements are true concerning logical and physical database structures? (Choose three.) All tablespaces may have one or more data files The extents of a segment must always reside in the same datafile A smallfile tablespace might be bigger than a bigfile tablespace A segment can span multiple data files in some tablespaces A segment’s blocks can be of different sizes A segment might have only one extent Segments can span multiple tablespaces 3,6,7 MC edit delete
3 1Z0-082 In the spfile of a single instance database, LOCAL_LISTENER is set to LISTENER_1. 03-quedb1.png Dynamic service registration cannot be used for this database instance The LREG process registers services dynamically with the LISTENER_1 listener LISTENER_1 must also be defined in the LISTENER.ORA file to enable dynamic service registration There are two listeners named LISTENER and LISTENER_1 running simultaneously using port 1521 on the same host as the database instances The definition for LISTENER_1 requires a CONNECT_DATA section to enable dynamic service registration 3 SC edit delete
2 1Z0-082 Which three statements are true about advanced connection options supported by Oracle Net for connection to Oracle Database instances? (Choose three.) Connect Time Failover requires the use of Transparent Application Failover (TAF). Source Routing requires the use of a name server Source Routing enables the use of Connection Manager (CMAN) which enables network traffic to be routed through a firewall Load Balancing can balance the number of connections to dispatchers when using a Shared Server configuration Load Balancing requires the use of a name server Connect Time Failover requires the connect string to have two or more listener addresses configured 2,3,6 MC edit delete
1 1Z0-082 Which statement is true about the INTERSECT operator used in compound queries? Multiple INTERSECT operators are not possible in the same SQL statement It processes NULLs in the selected columns INTERSECT is of lower precedence than UNION or UNION ALL It ignores NULLs 2 SC edit delete

Copyright © Designed & Developed by Sakthi Db Technology 2018